package com.atguigu.tingshu.search.service.impl;

import co.elastic.clients.elasticsearch.ElasticsearchClient;
import co.elastic.clients.elasticsearch._types.FieldValue;
import co.elastic.clients.elasticsearch._types.SortOptions;
import co.elastic.clients.elasticsearch._types.SortOrder;
import co.elastic.clients.elasticsearch._types.aggregations.Aggregate;
import co.elastic.clients.elasticsearch._types.query_dsl.BoolQuery;
import co.elastic.clients.elasticsearch.core.SearchRequest;
import co.elastic.clients.elasticsearch.core.SearchResponse;
import co.elastic.clients.elasticsearch.core.search.Hit;
import co.elastic.clients.elasticsearch.core.search.Suggestion;
import com.alibaba.fastjson.JSON;
import com.atguigu.tingshu.album.client.AlbumInfoFeignClient;
import com.atguigu.tingshu.album.client.CategoryFeignClient;
import com.atguigu.tingshu.common.constant.RedisConstant;
import com.atguigu.tingshu.common.constant.SystemConstant;
import com.atguigu.tingshu.common.execption.GuiguException;
import com.atguigu.tingshu.common.result.Result;
import com.atguigu.tingshu.model.album.*;
import com.atguigu.tingshu.model.search.AlbumInfoIndex;
import com.atguigu.tingshu.model.search.AttributeValueIndex;
import com.atguigu.tingshu.model.search.SuggestIndex;
import com.atguigu.tingshu.query.search.AlbumIndexQuery;
import com.atguigu.tingshu.search.repository.AlbumIndexRepository;
import com.atguigu.tingshu.search.service.SearchService;
import com.atguigu.tingshu.user.client.UserInfoFeignClient;
import com.atguigu.tingshu.vo.album.AlbumInfoVo;
import com.atguigu.tingshu.vo.album.AlbumStatVo;
import com.atguigu.tingshu.vo.search.AlbumInfoIndexVo;
import com.atguigu.tingshu.vo.search.AlbumSearchResponseVo;
import com.atguigu.tingshu.vo.user.UserInfoVo;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.cloud.context.config.annotation.RefreshScope;
import org.springframework.data.redis.core.RedisTemplate;
import org.springframework.stereotype.Service;
import org.springframework.util.Assert;
import org.springframework.util.CollectionUtils;
import org.springframework.util.StringUtils;

import java.io.IOException;
import java.util.*;
import java.util.concurrent.CompletableFuture;
import java.util.concurrent.ExecutionException;
import java.util.concurrent.ThreadPoolExecutor;
import java.util.function.Function;
import java.util.stream.Collectors;


@Slf4j
@Service
@RefreshScope
@SuppressWarnings({"all"})
public class SearchServiceImpl implements SearchService {

    @Autowired
    private AlbumInfoFeignClient albumInfoFeignClient;
    @Autowired
    private CategoryFeignClient categoryFeignClient;
    @Autowired
    private UserInfoFeignClient userInfoFeignClient;

    @Autowired
    private AlbumIndexRepository albumIndexRepository;

    @Autowired
    private ThreadPoolExecutor threadPoolExecutor;

    @Autowired
    private ElasticsearchClient elasticsearchClient;

    @Value("${ranking.dimension.array}")
    private String rankingDimensionArray;

    @Autowired
    private RedisTemplate redisTemplate;

    /**
     * 上架专辑
     *
     * @param albumId
     */
    @Override
    public void upperAlbum(Long albumId) {
        // 创建实体类对象
        AlbumInfoIndex albumInfoIndex = new AlbumInfoIndex();
        CompletableFuture<AlbumInfo> albumInfoCompletableFuture = CompletableFuture.supplyAsync(() -> {
            // 给album_info赋值
            Result<AlbumInfo> albumInfoResult = albumInfoFeignClient.getAlbumInfo(albumId);
            Assert.notNull(albumInfoResult, "查询专辑信息失败");
            AlbumInfo albumInfo = albumInfoResult.getData();
            Assert.notNull(albumInfo, "查询专辑信息失败");
            BeanUtils.copyProperties(albumInfo, albumInfoIndex);
            // 获取属性和属性值信息
            List<AlbumAttributeValue> albumAttributeValueVoList = albumInfo.getAlbumAttributeValueVoList();
            // 判断是否为空
            if (!CollectionUtils.isEmpty(albumAttributeValueVoList)) {
                // 循环遍历
                List<AttributeValueIndex> attributeValueIndexList = albumAttributeValueVoList.stream().map(albumAttributeValue -> {
                    // 创建实体类对象
                    AttributeValueIndex attributeValueIndex = new AttributeValueIndex();
                    attributeValueIndex.setAttributeId(albumAttributeValue.getAttributeId());
                    attributeValueIndex.setValueId(albumAttributeValue.getValueId());
                    return attributeValueIndex;
                }).collect(Collectors.toList());
                // 添加属性和属性值集合
                albumInfoIndex.setAttributeValueIndexList(attributeValueIndexList);
            }
            //返回数据
            return albumInfo;
        }, threadPoolExecutor).exceptionally(throwable -> {
            log.error("查询专辑信息失败：{}", throwable.getMessage());
            return null;
        });

        // 根据三级分类ID，查询视图 base_category_view
        // 获取到上一个返回值的结果并使用; select * from base_category_view where id = 1001;
        CompletableFuture<Integer> cateCompletableFuture = albumInfoCompletableFuture.thenApplyAsync(albumInfo -> {
            // 远程调用根据三级分类ID，获取分类数据
            Result<BaseCategoryView> categoryViewResult = categoryFeignClient.getBaseCategoryView(albumInfo.getCategory3Id());
            //判断数据
            Assert.notNull(categoryViewResult, "查询分类数据失败");
            BaseCategoryView baseCategoryView = categoryViewResult.getData();
            Assert.notNull(baseCategoryView, "查询分类数据失败");
            // 赋值
            albumInfoIndex.setCategory1Id(baseCategoryView.getCategory1Id());
            albumInfoIndex.setCategory2Id(baseCategoryView.getCategory2Id());
            return 1;
        }, threadPoolExecutor).exceptionally(throwable -> {
            log.error("查询分类数据失败：{}", throwable.getMessage());
            return 0;
        });

        // 查询并赋值 作者信息
        CompletableFuture<Integer> userCompletableFuture = albumInfoCompletableFuture.thenApplyAsync(albumInfo -> {
            // 远程调用
            Result<UserInfoVo> userInfoVoResult = userInfoFeignClient.getUserInfoVo(albumInfo.getUserId());
            Assert.notNull(userInfoVoResult, "查询作者信息失败");
            UserInfoVo userInfoVo = userInfoVoResult.getData();
            Assert.notNull(userInfoVo, "查询作者信息失败");
            albumInfoIndex.setAnnouncerName(userInfoVo.getNickname());
            return 1;
        }, threadPoolExecutor).exceptionally(throwable -> {
            log.error("查询分类数据失败：{}", throwable.getMessage());
            return 0;
        });

        // 统计信息: 根据专辑Id 查询专辑的统计数据;
        CompletableFuture<Integer> statCompletableFuture = albumInfoCompletableFuture.thenApplyAsync(albumInfo -> {
            // 统计信息：根据专辑Id 查询专辑的统计数据
            Result<AlbumStatVo> statVoResult = albumInfoFeignClient.getAlbumStat(albumId);
            // 判断数据
            Assert.notNull(statVoResult, "查询专辑统计数据失败");
            AlbumStatVo statVo = statVoResult.getData();
            Assert.notNull(statVo, "查询专辑统计数据失败");
            // 赋值
            // 播放量
            albumInfoIndex.setPlayStatNum(statVo.getPlayStatNum());
            // 订阅量
            albumInfoIndex.setSubscribeStatNum(statVo.getSubscribeStatNum());
            // 购买量
            albumInfoIndex.setBuyStatNum(statVo.getBuyStatNum());
            // 评论数
            albumInfoIndex.setCommentStatNum(statVo.getCommentStatNum());
            double hotScore = statVo.getPlayStatNum() * 0.2 + statVo.getSubscribeStatNum() * 0.3 + statVo.getBuyStatNum() * 0.4 + statVo.getCommentStatNum() * 0.1;
            //设置热度排名
            albumInfoIndex.setHotScore(hotScore);
            return 1;
        }, threadPoolExecutor).exceptionally(throwable -> {
            log.error("查询分类数据失败：{}", throwable.getMessage());
            return 0;
        });

        //  利用es的 api 进行数据保存：albumInfoIndex-->es;
        try {
            if (null == albumInfoCompletableFuture.get() || 0 == cateCompletableFuture.get() || 0 == userCompletableFuture.get()) {
                //  获取专辑失败;
                throw new GuiguException(20001, "远程调用获取数据失败");
            }
        } catch (InterruptedException e) {
            throw new RuntimeException(e);
        } catch (ExecutionException e) {
            throw new RuntimeException(e);
        }

        //  数据汇总：
        //  CompletableFuture.allOf(albumInfoCompletableFuture, cateCompletableFuture, userCompletableFuture).join();
        albumIndexRepository.save(albumInfoIndex);

    }

    /**
     * 下架专辑
     *
     * @param alnumId
     */
    @Override
    public void lowerAlbum(Long alnumId) {
        // 利用es的api 进行删除数据：albumInfoIndex -> es;
        albumIndexRepository.deleteById(alnumId);
    }

    /**
     * 检索
     *
     * @param albumIndexQuery
     * @return
     */
    @Override
    public AlbumSearchResponseVo search(AlbumIndexQuery albumIndexQuery) {
        // 构建dsl语句
        SearchRequest searchRequest = this.queryBuildDsl(albumIndexQuery);
        SearchResponse<AlbumInfoIndex> searchResponse = null;
        try {
            searchResponse = elasticsearchClient.search(searchRequest, AlbumInfoIndex.class);
        } catch (IOException e) {
            throw new RuntimeException(e);
        }
        // 赋值private List<AlbumInfoIndexVo> list = new ArrayList<>();
        AlbumSearchResponseVo albumSearchResponseVo = this.parseResultData(searchResponse);
        // 其他属性赋值
        albumSearchResponseVo.setTotal(searchResponse.hits().total().value());
        albumSearchResponseVo.setPageNo(albumIndexQuery.getPageNo());
        albumSearchResponseVo.setPageSize(albumIndexQuery.getPageSize());
        // 计算总页数 =（总条数 + 页大小 - 1）/ 页大小
        Long totalPages = (albumSearchResponseVo.getTotal() + albumIndexQuery.getPageSize() - 1) / albumIndexQuery.getPageSize();
        albumSearchResponseVo.setTotalPages(totalPages);
        //返回数据
        return albumSearchResponseVo;
    }


    private AlbumSearchResponseVo parseResultData(SearchResponse<AlbumInfoIndex> searchResponse) {
        AlbumSearchResponseVo albumSearchResponseVo = new AlbumSearchResponseVo();
        //  赋值-- private List<AlbumInfoIndexVo> list = new ArrayList<>();
        List<AlbumInfoIndexVo> list = new ArrayList<>();
        for (Hit<AlbumInfoIndex> hit : searchResponse.hits().hits()) {
            // 获取数据
            AlbumInfoIndex albumInfoIndex = hit.source();
            // 创建接收对象
            AlbumInfoIndexVo albumInfoIndexVo = new AlbumInfoIndexVo();
            // 属性拷贝赋值
            BeanUtils.copyProperties(albumInfoIndex, albumInfoIndexVo);
            // 判断是否有高亮显示
            if (null != hit.highlight().get("albumTitle")) {
                // 高亮字段
                String albumTitle = hit.highlight().get("albumTitle").get(0);
                // 将高亮字段赋值给对象
                albumInfoIndexVo.setAlbumTitle(albumTitle);
            }
            // 将对象添加到集合中
            list.add(albumInfoIndexVo);
        }
        // 赋值
        albumSearchResponseVo.setList(list);
        // 返回数据
        return albumSearchResponseVo;
    }

    private SearchRequest queryBuildDsl(AlbumIndexQuery albumIndexQuery) {
        // SearchRequest 本质就是Dsl语句封装类
        SearchRequest.Builder searchRequestBuilder = new SearchRequest.Builder();
        // bool
        BoolQuery.Builder boolQuery = new BoolQuery.Builder();
        // 指定索引库
        searchRequestBuilder.index("albuminfo");
        // 判断关键字是否为null
        if (!StringUtils.isEmpty(albumIndexQuery.getKeyword())) {
            // 不为null，要根据关键字查询，
            boolQuery.should(s -> s.match(m -> m.field("albumTitle").query(albumIndexQuery.getKeyword())))
                    .should(s -> s.match(m -> m.field("albumIntro").query(albumIndexQuery.getKeyword())))
                    .should(s -> s.match(m -> m.field("announcerName").query(albumIndexQuery.getKeyword())));
            // 以关键词查询有高亮，设置高亮

            searchRequestBuilder.highlight(h -> h.fields("albumTitle", f -> f.preTags("<span style=color:red>").postTags("</span>")));
        }
        // 判断分类id是否为null
        if (!StringUtils.isEmpty(albumIndexQuery.getCategory1Id())) {
            // 根据一级分类id过滤
            boolQuery.filter(f -> f.term(t -> t.field("category1Id").value(albumIndexQuery.getCategory1Id())));
        }
        if (!StringUtils.isEmpty(albumIndexQuery.getCategory2Id())) {
            // 根据二级分类id过滤
            boolQuery.filter(f -> f.term(t -> t.field("category2Id").value(albumIndexQuery.getCategory2Id())));
        }
        if (!StringUtils.isEmpty(albumIndexQuery.getCategory3Id())) {
            //根据三级分类id过滤
            boolQuery.filter(f -> f.term(t -> t.field("category3Id").value(albumIndexQuery.getCategory3Id())));
        }
        //  用户还可能通过属性与属性值进行过滤;
        List<String> attributeList = albumIndexQuery.getAttributeList();
        if (!StringUtils.isEmpty(attributeList)) {
            // 循环遍历
            for (String attribute : attributeList) {
                String[] split = attribute.split(":");
                if (null != split && split.length == 2) {
                    boolQuery.filter(f -> f.nested(n -> n.path("attributeValueIndexList").query(q -> q.bool(b -> b.must(m -> m.term(t -> t.field("attributeValueIndexList.attributeId").value(split[0])))
                            .must(m -> m.term(t -> t.field("attributeValueIndexList.valueId").value(split[1])))))));
                }
            }
        }

        // 分页  (pageNO - 1) * pageSize
        Integer from = (albumIndexQuery.getPageNo() - 1) * albumIndexQuery.getPageSize();
        searchRequestBuilder.from(from);
        searchRequestBuilder.size(albumIndexQuery.getPageSize());
        // 排序：排序（综合排序[1:desc] 播放量[2:desc] 发布时间[3:desc]；asc:升序 desc:降序）
        String order = albumIndexQuery.getOrder();
        // 判断是否有排序功能
        if (!StringUtils.isEmpty(order)) {
            // 字符串分割
            String[] split = order.split(":");
            if (null != split && split.length == 2) {
                String field = "";
                switch (split[0]) {
                    case "1":
                        // 综合排序
                        field = "hotScore";
                        break;
                    case "2":
                        // 播放量排序
                        field = "playStatNum";
                    case "3":
                        // 发布时间排序
                        field = "createTime";
                }
                // 设置排序字段
                String finalField = field;
                searchRequestBuilder.sort(s -> s.field(f -> f.field(finalField).order("asc".equals(split[1]) ? SortOrder.Asc : SortOrder.Desc)));
            }
        }
        // 设置bool -> query中
        searchRequestBuilder.query(boolQuery.build()._toQuery());

        SearchRequest searchRequest = searchRequestBuilder.build();
        // 打印dsl语句
        System.out.println("DSL:\t" + searchRequest.toString());
        return searchRequest;
    }

    /**
     * 自动补全
     *
     * @param keyword
     * @return
     */
    @Override
    public List<String> completeSuggest(String keyword) {
        // 编写dsl语句
        SearchResponse<SuggestIndex> searchResponse = null;
        try {
            searchResponse = elasticsearchClient.search(s -> s.index("suggestinfo")
                            .suggest(s1 -> s1.suggesters("suggest_keyword",
                                            f -> f.prefix(keyword).completion(c -> c.field("keyword").skipDuplicates(true).fuzzy(f1 -> f1.fuzziness("auto")).size(10)))
                                    .suggesters("suggest_keywordPinyin",
                                            f -> f.prefix(keyword).completion(c -> c.field("keywordPinyin").skipDuplicates(true).fuzzy(f1 -> f1.fuzziness("auto")).size(10)))
                                    .suggesters("suggest_keywordSequence", f -> f.prefix(keyword).completion(c -> c.field("keywordSequence").skipDuplicates(true).fuzzy(f1 -> f1.fuzziness("auto")).size(10))))
                    , SuggestIndex.class);
        } catch (IOException e) {
            throw new RuntimeException(e);
        }
        // 获取到查询结果集：
        List<String> list = new ArrayList<>();
        // 定义一个方法：
        list.addAll(this.getSuggestList(searchResponse, "suggest_keyword"));
        list.addAll(this.getSuggestList(searchResponse, "suggest_keywordPinyin"));
        list.addAll(this.getSuggestList(searchResponse, "suggest_keywordSequence"));
        // 返回数据
        return list;
    }

    /**
     * 获取提词库数据
     *
     * @param searchResponse
     * @param suggestKeywordPinyin
     * @return
     */
    private Collection<String> getSuggestList(SearchResponse<SuggestIndex> searchResponse, String keyword) {
        // 根据key 获取options
        List<Suggestion<SuggestIndex>> suggestionList = searchResponse.suggest().get(keyword);
        if (!CollectionUtils.isEmpty(suggestionList)) {
            for (Suggestion<SuggestIndex> suggestIndexSuggestion : suggestionList) {
                return suggestIndexSuggestion.completion().options().stream().map(option -> option.source().getTitle()).collect(Collectors.toList());
            }
        }
        // 返回数据
        return new ArrayList<>();
    }

    /**
     * 获取频道页数据
     * @param category1Id
     * @return
     */
    @Override
    public List<Map<String, Object>> channel(Long category1Id) {
        // 先根据一级分类Id获取到三级分类集合数据（远程调用）
        Result<List<BaseCategory3>> baseCategory3ListResult = categoryFeignClient.findTopBaseCategory3(category1Id);
        // 判断是否为空
        Assert.notNull(baseCategory3ListResult, "查询三级分类集合失败");
        List<BaseCategory3> baseCategory3List = baseCategory3ListResult.getData();
        // 判断是否为空
        Assert.notNull(baseCategory3List, "查询三级分类集合失败");
        // 获取到三级分类Id集合
        List<Long> category3IdList = baseCategory3List.stream().map(BaseCategory3::getId).collect(Collectors.toList());
        // 通过三级分类Id查找三级分类对象   Map(key:BaseCategory3::getId,value:Function.identity())   Function.identity()等价t -> t （Function.identity() 直接使用对象本身作为值）
        Map<Long, BaseCategory3> category3Map = baseCategory3List.stream().collect(Collectors.toMap(BaseCategory3::getId, Function.identity()));
        // FieldValue.of() 将 Java 的 Long 类型 ID 转换为 Elasticsearch 可识别的 FieldValue 类型
        List<FieldValue> fieldValueList = baseCategory3List.stream().map(baseCategory3 -> FieldValue.of(baseCategory3.getId())).collect(Collectors.toList());
        // 专辑集合列表
        SearchResponse<AlbumInfoIndex> searchResponse = null;
        try {
            searchResponse = elasticsearchClient.search(s -> s.index("albuminfo")
                            .query(q -> q.terms(t -> t.field("category3Id")
                                    .terms(t1 -> t1.value(fieldValueList))))
                            .aggregations("agg_category3Id", a -> a.terms(t -> t.field("category3Id"))
                                    .aggregations("topSixHotScoreAgg", a1 -> a1.topHits(t1 -> t1.size(6)
                                            .sort(s1 -> s1.field(f -> f.field("hotScore").order(SortOrder.Desc)))))
                            )
                    ,
                    AlbumInfoIndex.class);
        } catch (IOException e) {
            throw new RuntimeException(e);
        }
        // 获取结果组装数据
        // TODO: 再看看
        Aggregate aggregate = searchResponse.aggregations().get("agg_category3Id");
        List<Map<String, Object>> list = aggregate.lterms().buckets().array().stream().map(bucket -> {
            // 存储数据：需要创建一个map集合
            HashMap<String, Object> map = new HashMap<>();
            // 获取key
            long category3Id = bucket.key();
            // 存储第一个数据三级分类对象：baseCategory3.name
            map.put("baseCategory3", category3Map.get(category3Id));
            // 获取专辑集合列表
            Aggregate toSixHotScoreAgg = bucket.aggregations().get("topSixHotScoreAgg");
            List<AlbumInfoIndex> albumInfoIndexList = toSixHotScoreAgg.topHits().hits().hits().stream().map(hit -> JSON.parseObject(hit.source().toString(), AlbumInfoIndex.class)).collect(Collectors.toList());
            map.put("list", albumInfoIndexList);
            // 返回map
            return map;
        }).collect(Collectors.toList());
        // 返回数据
        return list;
    }

    /**
     * 更新排行榜
     */
    @Override
    public void updateLatelyAlbumRanking() {
        // 1.远程调用，获取所有一级分类数据：select * from base_category1
        Result<List<BaseCategory1>> listResult = categoryFeignClient.findAllCategory1();
        Assert.notNull(listResult,"查询一级分类数据失败");
        List<BaseCategory1> baseCategory1List = listResult.getData();
        Assert.notNull(baseCategory1List,"查询一级分类数据失败");
        // 获取排序的维度
        String[] split = rankingDimensionArray.split(",");
        // 循环变量集合，调用es客户端生成的dsl语句并执行获取结果集并放入缓存！
        for (BaseCategory1 baseCategory1 : baseCategory1List) {
            // 获取一级分类id
            Long category1Id = baseCategory1.getId();
            for (String rangking : split) {
                // 调用es api
                SearchResponse<AlbumInfoIndex> searchResponse = null;
                try {
                    searchResponse = elasticsearchClient.search(s -> s.index("albuminfo")
                                    .query(q -> q.term(t -> t.field("category1Id").value(category1Id)))
                                    .sort(s1 -> s1.field(f -> f.field(rangking).order(SortOrder.Desc)))
                            , AlbumInfoIndex.class);
                } catch (IOException e) {
                    throw new RuntimeException(e);
                }
                // 获取集合列表
                List<AlbumInfoIndex> albumInfoIndexList = searchResponse.hits().hits().stream().map(Hit::source).collect(Collectors.toList());
                // 将每次获取的数据添加到缓存中
                redisTemplate.opsForHash().put(RedisConstant.RANKING_KEY_PREFIX+category1Id,rangking,albumInfoIndexList);
            }
        }
    }

    /**
     * 获取排行榜
     * @param category1Id
     * @param rangking
     * @return
     */
    @Override
    public List<AlbumInfoIndex> finfindRankingList(Long category1Id, String rangking) {
        // hget key field;
        return (List<AlbumInfoIndex>) redisTemplate.opsForHash().get(RedisConstant.RANKING_KEY_PREFIX+category1Id,rangking);
    }
}
